package com.zzyl.mapper;


import com.github.pagehelper.Page;
import com.zzyl.dto.NursingProjectPageDTO;
import com.zzyl.entity.NursingProject;
import com.zzyl.vo.NursingProjectVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface NursingProjectMapper {

    Page<NursingProjectVo> pageCondition(NursingProjectPageDTO nursingProjectPageDTO);

    Integer projectRefCount(Long id);

    void insert(NursingProject nursingProject);

    @Select("select * from nursing_project where id = #{id}")
    NursingProjectVo getById(Long id);

    void update(NursingProject nursingProject);

    @Select("select * from nursing_project where is_delete = 0")
    List<NursingProjectVo> selectAll();

}
